BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
ENTHU
Community Trekker

Extracting substring and converting to column

Hi,

 

Need some help with proceesing a long string.

I have a table with several columns;one column has a long string as follows-

EntitySubstring
ARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.31

I need to remove first four characters "RWYT" and expected output is as follows:

 

EntitySubstringZZRZQ_pp29_Nxy13_7ZZRZQ_pp29_Nxy13_3ZZRZQ_pp29_Nxy13_5
ARWYT|ZZRZQ_pp29_Nxy13_7|54.58|ZZRZQ_pp29_Nxy13_3|51.72|ZZRZQ_pp29_Nxy13_5|54.3154.5851.7254.31
0 Kudos
1 REPLY 1
txnelson
Super User

Re: Extracting substring and converting to column

The character functions are all very nicely organized in the Scripting Index.  When you need to manipulate a string, you can very easily go through the various functions and the examples shown, to determine which one to use.......You need to spend the time to do this!

 

For what you are trying to do....

Names Default to Here( 1 );
dt = Current Data Table();

For Each Row(
     :Substring = Substr(:Substring, 5);
);
Jim
0 Kudos