A quite complicated string task

[EvenDeejay]

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?

[johnsold · Accepted solution]

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

[P@Anand]

Please save your VI in 8.6 and post

[johnsold]

Here is my VI saved back to LV8.0.  The original VI just had the Array to Spreadsheet String part at the top.

Lynn

[DaHelmut]

Maybe this is Rube Goldberg Code but, here is my version using regular expressions and so on... :

File in LV 8.0.

Regards,

[DaHelmut]

This version corrects a mistake concerning the regular expressions I used.

[jcarmody]

This Regular Expression uses a backreference and grouping to extract the letter and start/end numbers; the rest is easy.

[jcarmody]

I explained the regular expression here.

[DaHelmut]

---

I explained the regular expression here.

Jim, CLD

---

Hi Jim,

This is awesome !

Thanks ! I learned a lot today thanks to you and your example.

Regards,

[jcarmody]

---

@helmut O'Brian wrote:

Thanks ! I learned a lot today thanks to you and your example.

Regards,

---

You're welcome.  I learned everything I know from the link in my signature and Darin.K.