How can I get 566 and 2657 in string

[suzel404]

Hi all,

How can I get  566 and 2657 in string :

5-300 |  6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800

Thanks for your help.

[ThornOfCrowns]

Adding it to the string or taking it out?

[its_anandrjs · Accepted solution]

Hi,

Load this  way

S:

LOAD String,Left(Trim(SubField(String,'|')),1) as New;

LOAD * Inline

[

String

5-300 | 6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800

];

NoConcatenate

LOAD

String,

Concat(New,'') as NewString

Resident S

Group By String;

DROP Table S;

Regards

Anand

[morganaaron]

Not an elegant solution but:

Left(SubField(PurgeChar([Field Name],' '),'|',1),1) & Left(SubField(PurgeChar([Field Name],' '),'|',2),1) & Left...

Where [Field Name] is the name of your field above, and then repeat this as many times as you needed (in your example you'd need 4) changing the number after the '|' delimiter in the SubField function.

[anbu1984]

Load PurgeChar(Left(Txt,1) & TextBetween(Txt,'|','-',1) & TextBetween(Txt,'|','-',2) & TextBetween(Txt,'|','-',3) & TextBetween(Txt,'|','-',4),' ') As Str;

Load * Inline [

Txt

5-300 |  6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800 ];

[suzel404]

Thanks you for your response!!