Hi everyone! I’m new to Parabola and have a question on find/replace.
I currently have a column filled with email formats (ex. FirstName.LastName@yahoo.com) that give 1 particular format per row. I’m looking to use values from the other columns in that row (ex. FirstName and LastName) to find and replace terms in the format column so I’m left with a particular email (for a given row, FirstName column → Jane, LastName column → Smith, so Format column → Jane.Smith@yahoo.com).
Is this possible to do in Parabola? I’ve tried using the find and replace function but it seems like I can’t pass a column name in with brackets.
Thanks in advance!