Help in the load script with right function .?

[ashmitp869]

Hi All,

I have values in variable like -

3000001-77777

344444-8888888

444444

My req to get the values like below in load script -

77777

8888888

444444

[MayilVahanan · Accepted solution]

Hi

Try like below

Data:
LOAD SubField(F1, '-', SubStringCount(F1, '-')+1) as F1 INLINE [
F1
3000001-77777

344444-8888888

444444
];

[rwunderlich]

Don't forget that the 3rd parameter to subfield can be negative -- counts from right. 

SubField(F1, '-', -1) 

-Rob