Adding a 0 to the start of a phone number

[Ian_Bottomley]

We've noticed a significant number of records in Marketo have a phone number which does not start with '0' is there a straightforward way in which to mass update those records to add this in please or would the data need to exported, amended and re-uploaded? 

[SanfordWhiteman · Accepted solution]

This is one case where yes, you can do it directly in a flow.

Change Data Value where the new value is

0{{lead.Phone Number}}

Obviously test on a few people first!

[SanfordWhiteman · Accepted solution]

This is one case where yes, you can do it directly in a flow.

Change Data Value where the new value is

0{{lead.Phone Number}}

Obviously test on a few people first!

[Ian_Bottomley · Accepted solution]

That's great thank you for your help.