Convert String into Double + String

[userid128223]

Thx

How do you read a string and convert into DUAL + STRING and also remove leading zeros.

String:

AIOU002343443

000000URREI34343438

[vvira1316]

Hi,

Include more sample data to better understand the patterns and to come up with logic/functions that will help you.

BR,

Vijay

[sunny_talwar]

What would be the expected output in the above sample data?

[prma7799]

Please share sample file with expected output.

[tresesco]

May be this?

=Dual(<YourString>, Replace(Ltrim(Replace(Keepchar(<YourString>,'1234567890'),'0',' ')), ' ','0'))

[jonathandienst]

Perhaps this:

Dual(

  Replace(LTrim(Replace(field, '0', ' ')), ' ', '0'),

  Num(KeepChar(field, '0123456789'))

)

The Replace() will strip the lading zeroes from the text part and the Num() will strip the leading zeroes from the numerical portion.