Latest Contributions by LindsayRaabe_FPCWA

This idea has already been covered here: Simultaneous use of offline areas and online map - Esri Community. Might also note the huge amount of Kudo's it has received! Worth adding more to it still.  ... View more

You're right - I forgot to include the triple quotes (yes, I had seen the other post). I added them in and it worked - sort of. I gave me a result, but one that still contains the new line characters. I believe the triple quotes has solved the input value issue, but still hasn't resulted in a query that removes the new line values from the output value.    However.....   I tried out Duncan's suggestion of putting the new line characters into the function call, and TaDa! Managed to get out a single line of text! This is good news because now I can do away with the separate python script tool that I was using the achieve the same result! Thanks all for your input and patience! ... View more

I just tried my code block with the line you suggested.      Assuming I've written it correctly, it still doesn't seem to work (I have tried chr(10), "chr(10)", {chr(10)}  and "{chr(10}" as well without any luck). All come up with the below error.  ... View more

Thanks for the tip. I tried that in the Code Block and it still moved the following text to a new line....so I decided to try something else. I've created a python script with the function in it loaded as a script in my Toolbox and model with an input parameter (the path to my .txt file) and an output parameter (the new single-line string). I can get it to run the function successfully, removing "\n" and replacing it with "", and I WAS struggling to get the value out as a parameter I can feed into another model step, but have just discovered I had called the function result incorrectly. Here's my methodology to get the text file input to a value I can use in Field Calculator: And the code as a sample: import re import arcpy inFile = open(arcpy.GetParameterAsText(0)).read() def Result(Value): inValue = Value newValue = inValue.replace("\n", "") re.sub('\s{2,}', ' ', inValue) # To remove more than one space #print (newValue) return newValue outText = Result(inFile) arcpy.AddMessage(outText) #print(outText) arcpy.SetParameterAsText(1, outText)   A big thank you to @Luke_Pinner for your pointers. I would not have got this far without them.  ... View more

Trying to fix the issue by turning the multiline text file into a single, long string. Started a new expression as per below, but the Code block keeps removing the \n and just moving the text onto a new line.   becomes this: So I tried this too: but get this error: which is the same error I get from just running the field calculator with the original multiline text value. So frustating! ... View more

Nearly worked! It did indeed calculate the Value as you suggested (just using the Expression instead of the code block) but the calculate field step failed where it encountered the new line.    ... View more

I feel like I'm getting closer - but still need guidance. I've created a Calculate Value Code Block as per below but have 2 problems (at least, 2 for now):   1. I can't figure out how to replace the written file path on line 4 with the pathway from the variable (which is a text file) i.e. path = (str_path). When I do, I get the below error.  2. When I run it successfully as per the original script, the output Value is still blank (at least as far as I can tell).    ... View more

Thanks for the suggestion. I've had a look at that now and don't think that's really a viable option. Would it be possible to load the text in a text file (using the Text File variable) and use a python code to extract the text and calculate field? ... View more

I assume text boxes are not an option? Could a text file work in place of a text line/box? ... View more

I find it annoying when the first time I click in the Command Search box at the top of Pro that it thinks about loading all the tools for a while before working. Surely this can happen after project open in the background before someone accesses the search function.   ... View more