Maintaining leading zeros in text

[anon29779373]

Example of Amazon ASIN/ISBN

0321914228 (turns to 321914228 while uploading as CSV)
1285165918 (right format)
013354642X (The ‘0’ stays on this while uploading as CSV - maintains right format despite leading zero)

The Field is set to text, I’d like to format all as “0000000000” Like Excel can do (Ten characters maintained)

Any Ideas appreciated. Thank you.

[mishav]

I’d like to format all as “0000000000”

One way …

text:find & replace:truncated from end to 10

Set a regular expression,
pattern ^
replace 000000000

The ^ matches the start of the string, so in effect it prepends the zeroes into the text.

Maybe an unwanted side-effect, this does truncate anything longer than ten characters from the left side.

[anon29779373]

Worked! No ASIN over 10 characters so all good