Forum Discussion
jmetf150
Helper I
Helper IReplace First Name Last Name with First Initial Last Name;
Is there a simply way to do this in "Transform Data" or would you recommend a certain function/formula? Code First & Last Name Desired Output (Relplace Text not create new column) G14 ...
Hi jmetf150 ,
Here are the steps you can follow：
1. Create calculated column.
Test = var _find= SEARCH(" ",[First & Last Name],1) var _len= LEN([First & Last Name]) var _test= RIGHT( [First & Last Name],_len-_find) return LEFT( [First & Last Name],1)&". "&_test2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi jmetf150 ,
Here are the steps you can follow：
1. Create calculated column.
Test =
var _find=
SEARCH(" ",[First & Last Name],1)
var _len=
LEN([First & Last Name])
var _test=
RIGHT(
[First & Last Name],_len-_find)
return
LEFT(
[First & Last Name],1)&". "&_test2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly