Hello guys! Today I got into a bit of mess when making a program for my company. I'm reading from a .csv file which is containing information regarding electric components. I have to read the cell into an array for further use. No problem at all. Now the hard part: Lets say a cell in the .csv file contained this: C1-C10 I put it into an array and still have: C1-C10 (C1-C10 means there are actually ten cmponents; C1, C2, C3...C10) I now want to convert the array containing C1-C10 into an array looking like this: C1 C2 C3 . . . C10 (Se attachment LV2010) I think a solution is to remove the C from the string and then look at the numbers and find out how many components there are. Then put it back with a C in front and create ten incrementing numbers like this: C1-C10 => 1-10 = Ten elements => Create numbers: 1,2,3,4,5,6,7,8,9,10 => Add C in front of the numbers. Anyways this algorithm has to be capable for any letters and numbers, i.e. R2-R5, K2-K7 etc... Anyone which has done a similar thing and maybe can help me in the right direction on where to start?

Here is my attempt. I split the string at "-" with Match Pattern and then search each substring for leading letters. Use the numeric parts to create an array of integers and convert back to strings. Lynn

LabVIEW

A quite complicated string task

Solved!

Author

First off all, thank you very much for all the answers! This was way more than I asked for. I learned a lot from your examples and how to manipulate strings and use stuff from the string palette.

I realized yesterday that the only problem was me and LabVIEW. 5 months is not too much to brag about. Luckily my boss approved so I can do the Core 2 and Core courses next year:)

So Kudos to you all and again, thank you so much for the lesson:)

Regards,
Even
_________________________________
Certified LabVIEW Associate Developer

Automated Test Developer
Topro AS
Norway

Message 11 of 11

(394 Views)

LabVIEW

A quite complicated string task

Re: A quite complicated string task