Home

Text Strings

%3CLINGO-SUB%20id%3D%22lingo-sub-354262%22%20slang%3D%22en-US%22%3EText%20Strings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20the%20following%20text%20string%3A%3C%2FP%3E%3CP%3E%5Btext%20name%3D%22%2CJ1%2C%22%20memo%3D%22%2CA1%2C%22%20size%3D%223%22%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20this%20in%20another%20program.%20There%20are%20about%20300%20lines%2C%20and%20all%20the%20data%20is%20already%20in%20a%20spreadsheet%20format.%20Cells%20J1%20%26amp%3B%20A1%20are%20the%20only%20references%2C%20everything%20else%20is%20constant.%3C%2FP%3E%3CP%3EJ1%3DLAB_1%3C%2FP%3E%3CP%3EA1%3DRBC%20(Male)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20finished%26nbsp%3Bstring%20should%20look%20like%3A%3C%2FP%3E%3CP%3E%5Btext%20name%3D%22lab_1%22%20memo%3D%22RBC%20(Male)%22%20size%3D%223%22%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-354262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354740%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Strings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354740%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3D%22%5Btext%20name%3D%22%22%22%26amp%3BJ1%26amp%3B%22%22%22%20memo%3D%22%22%22%26amp%3BA1%26amp%3B%22%22%22%20size%3D%22%223%22%22%5D%22%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Bryan_Broyles
Occasional Visitor

I need to create the following text string:

[text name=",J1," memo=",A1," size="3"]

 

I am using this in another program. There are about 300 lines, and all the data is already in a spreadsheet format. Cells J1 & A1 are the only references, everything else is constant.

J1=LAB_1

A1=RBC (Male)

 

So my finished string should look like:

[text name="lab_1" memo="RBC (Male)" size="3"]

 

Help?

1 Reply

That could be

="[text name="""&J1&""" memo="""&A1&""" size=""3""]"
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies