Triggered action to replace leading character in string on insert

[Roosta]

Hello all,

So I have been going round in circles with this and have admitted I need help!

This is in the UK and we have phone numbers and other information uploaded into a table using EasyCSV, the problem is the numbers need to be formatted with no spaces (have this bit covered) and start with 44 (UK dialling code) for use in an external system. The field that stores the number is formatted as text and unfortunately numbers often sometimes get uploaded as 07111 022096 (no idea if this number exists just a random example of format) when the required format would be 447111022096

What I need is a trigger on insert of data to the table to check if the first number is a 0 and if so replace with 44 if it is, I have tried various methods but end up replacing all the 0's in the string with 44 so it ends up looking something like 44711144224496 

Any help would be greatly appreciated cheers, Roosta

[CoopperBackpack]

Hello @Roosta,

You can use the following approach: the condition checks if the first character is zero and if the condition is met concatenates 44 and the number without the first character.

This works if the phone number is stored in the Text(255) field.

 

[Roosta]

Hello @CoopperBackpack

This works perfect thanks, you truely are a Caspio Rockstar and this is greatly appreciated 

Cheers, Roosta

 

[Flowers4Algernon]

Hello! Can I also suggest looking into this link for more information regarding triggered actions?: https://howto.caspio.com/triggered-actions/triggered-actions-2/

[Roosta]

@Flowers4Algernon had already resolved and well aware of triggered actions as use them quite frequently with complex actions this was a specific use case I couldn't quite get the syntax right but thanks for the link.