Transformers

Hello everybody,   My problem : I have a "Description" attribute which contains text with length variable. The lenght is greater than 2000 characters. For each feature of the "Description" attribute, I want to replace all spaces after every 80 characters with "LF" (new line).   So I thank use StringReplacer to write a regular expression to calculate 80 characters intervals and identify the space after each 80 characters. Then I could have replace this by LF.  I helped myself with these topics on the forum: - https://knowledge.safe.com/questions/51531/how-do-i-find-the-first-space-after-the-19th-chara.html  - https://knowledge.safe.com/questions/51514/splitting-attributes-by-number-of-words.html  - https://knowledge.safe.com/questions/40715/count-the-number-of-characters-and-numbers-in-a-gi.html   But I d'ont success it. Maybe I don't really understand explanations....   Do you have any leads ?   Thank you so much !      

Hello,I'm trying to read an OCRd pdf_text attribute and get the text between 2 lines.My regexp is (?=Detail : Verbruik vaste telefonie ).*(?=Detail : Verbruik mobiele telefonie )but my result is strangeIt does not end on "Detail : Verbruik Mobiele telefonie". Is there an error in the RegExp?

I have used String Searcher to find data with the name BORDERHowever,I am struggling finding the right transformer which will combine the two records into 1 : this is based on number.ie - combine40_BORDER_QB40_QD_BORDERthen rename the record afterwardsto : ie - 40_QD_QB this will also have to be done for 65_GF_CR and 67_GF_CR   then merging with Provider data.

Hi,I have different councils Pipe material list with a specific example of say Copper – which different council has a different way to define it.. say for example one council called it “CU”, other council calls it “COP” and some other councils call it with some other name…however, the material is the same…and in general we want to define a common name for it..... say "Copper"? Can we create a data dictionary in FME?...which can identify and recognize the correct name and replace it with a generic name?  

Hey there,Building on the question in this link: https://knowledge.safe.com/questions/70747/finding-the-largest-value-through-multiple-attribu.htmlI want to find the attribute that the max value in the function @max(Value(A), Value(B), Value(C) belonged to. See image below for example:Is there any function in FME that could help me with this? As the title implies, I thought something like @argmax(...) would exist, but I have not found what I am looking for.Thanks in advance

Hi, I have two inputs to a raster mosaicker and would like them to retain the full extends of the combination of the two inputs yet is doesnt seem to: I basically want to have a nice -180,-90,180,90 geotiff. any gaps from the bottom raster input needs to be filled with no data (coming from the top input). Any idea why the RasterMosaicker isnt doing this.Thank you very much for your help in advance.Oliver 

Hi,I have birth days in this format YYYY-MM-DD.I want to calculate their ages.Per exemple, someone born 1950-03-28 would be 70 years old.Not sure how to do that. Any idea?Thanks

Hello Just need some guidance:  I'm currently using SystemCaller + AttributeFilter (0 & 1 for error logging) as a workspace to run a batch file daily which does the following:- Delete existing log files- Create WinScp log file- After setting some variables then log in to SFTP server using WinSCP commands- Upload a file, check its existence on remote server and if exist then upload the respective ".Done" empty file from local server. Exit with Code 0. If failure then abort and always exit with Code 1.- Catch error in case of failure and output it to error.txt (it will tell me which file failed)- Script repeats the same process for the remaining 4 datasets.E-mailer attached to attribute filter 1That's working. I want to:Option 1Use automation to achieve the same result albeit SFTP "External Action" fails to validate the connection and states "Invalid - Path not found". For now I've given up on trying to understand so will skip that option.Opt

hi sirgood daykindly could you confirm if you have software to transfer scanned drawing from JPG to DWG; so i can re modify the drawing. if yes, can you tell me the price of licencing.

Hi, I am trying to read point geometry from a Microsoft SQL Server database and the geometry is displaying in the 'Geometry' attribute like the following example: 'C0FFD20FBC8CCF11ABDE08003601B769D9CEF75331C9F0405EBA490C1EABE44015AE47E17A746140'.I would like this geometry to display in the inspector but am having trouble working out how to do this.I have tried using the 'GeometryExtractor' transformer, first setting the 'Geometry Encoding' to 'FME Binary'. But this results in '3160A883220000000000' being output for every single record in the _geometry attribute and no geometry in the inspector.When I tried setting 'Geometry Encoding' to 'Microsoft SQL Server Binary' I got 'FFFFFFFF' for very record in the _geometry attribute and again no geometry in the inspector.Does anyone know what else I could try? It's my first time reading from Microsoft SQL Server in this way..Thanks!

Hi! I hope you can help with this very basic problem of mine..(although too much to handle for me). So, what I want to do is load data into a sde database. It´s annotations, in coverage format. And what I have seen so far of the result when I only use a simple ”in-data to out-data”-workspace in FME is that the texts don´t end up in a correct way. There are overlaps for example. Then I thought that the only way to do it correctly is with the ”Import Coverage”-tool in ArcGIS. So I created a simple Model Builder model which I then exported to a python script. Below is a screen shot of the model and further down is the script. Script from model export:# Import arcpy moduleimport arcpy # Local variables:tx_24_annotation_tx_24 = "D:\\\\Vagkarta\\\\Shape\\\\vk_24_Sweref_99_TM_shape\\\\vagk\\\\24\\\\tx_24\\\\annotation.tx_24"tx_25_annotation_tx_25 = "D:\\\\Vagkarta\\\\Shape\\\\vk_25_Sweref_99_TM_shape\\\\vagk\\\\25\\\\tx_25\\\\annotation.tx_25"sde_gsd_GNG_vk_tx_anno_modelb

Hello!I have two tables:Table 1:NameBasevalueaaa0bbb0bbb5bbb11ccc0 Table 2:NameValuebbb3bbb8bbb10ccc8 Now I want to get for each feature from table 2 the nearest smaller 'Basevalue' from table 1 compared to the 'Value' of table 2.The Result should look like this:NameValueResultValuebbb30bbb85bbb105ccc80 Any ideas how to do so?GreetingsStefan

Hi, I have a csv file with some coordinates in the following form: Cordinaten gps longitude ; Cordinaten gps latitude 4.438.469 ; 5.186.713 How can I convert this to EPSG:28992? I've already tried the Reprojector, AttribureReprojector and CsmapAttributeReprojector but that didn't help. Thank you in advance.  Greetings, Hans

The shapefile writer (2015 vintage) used to have an option of character encoding - ANSIWhat did this actually mean, iso-8859-1?

Does FME recognise different epochs for WGS84?

Hi, I want to convert ESRI annotation (ESRI geodatabase ArcSDE) to line. (I don't mind if I get the underline insted of the centerline)I've try the EsriAnnotationRenderer transformer and even if the annotation have underline, it only return the text. I've also try the GeometryCoercer transformer but it doesn't work with text.is there a way to do this ? Thanks   

Hi,I would like to break a line into segments and then assign a sequential order attribute starting at the start of the line.For example, in my screenshot, if I break the line into 500m segments, I would like section 1 to go from the start point to 500m, section 2 to go from 500m to 1000m, and so on to the end of the line.I've tried using the iterative snipper and the chopper to break the line but the problem is that they both output the line segments in a random order.Would anyone know how I might do this?Thanks. 

I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?Thank you for any views on this.

 First datasetI created about 1 million lines between 1565 points. These points are locations and the lines are possible routes over a network between the locations. Many of these lines (=routes) overlap each other. This is my first dataset.Second datasetMy second dataset consist also of lines. Part of these lines have an attribute value for attribute 'VWH' = 1. The other lines have a value of 0, VWH = 0.AnalysisWhat I want to do now is to perform an intersection between the first and second dataset. For the second dataset the features are used where VWH = 1. Using the VWH =1 features I want to intersect dataset 1 and attach the VWH value to overlapping lines. See the figure below for the main idea.First I dissolved dataset 2, for VWH =1, into one multipart feature using the LineCombiner followed by the Aggregator. The length of this multipart line feature is 7684 km.Then I used a SpatialFilter to check which features of dataset 1 intersect the multipart feature.Then I tried di

I have a block of text separated by newline characters, e.g:Some TextSome More TextEven More TextPERIOD: 01/01/1990 TO 12/12/2020What I'm attempting to do using regex is grab the entire line of text preceding the row beginning with PERIOD (i.e. "Even More Text"). In an online regex editor, the following expression successfully returns just the line containing "Even More Text":^.*$(?=\\nPERIOD)However, when I attempt to do the same in FME, it returns all lines above PERIOD. It seems as though in online editors the . includes all characters except newlines, whereas in FME it includes them? Is there a way to adjust multiline regex flags (or some other workaround) in FME to get the desired output?

I am new to FME. Is there somewhere I can download basic templates of FME projects? I am currently looking for something to count the number of files / folder in a Windows directory. I assume that is pretty basic, but I have no idea how to start. After I locate a simple template I can take it apart and learn more on how to create my own.Thanks,Dan

Dear all,I need help with task. I have two rasters grom the same place: NIR 1 channel and RGB 3 channel.  I need to replace on RGB raster Red channel with NIR channel and save raster.  How can i do this? Thank you on advance for help

Hey, currently I am using a centerPointReplacer to create points in the middle of cemetery plots (polygons), that meet a certain criteria (they have a photo attached to them). The points are being created in the 'Centre of Gravity Point', it works well, see black dots below, they are all in the middle of our graves:As you can see, the labels of these cemetery plots are covering the dots (or close to), and I am wondering if there is a way I can consistently move these dots to be offset, towards a common narrow end of the polygon? I dont want to use a random spot, as these will not be visually appealing, so I am hoping to move the dots to be along a common side, something like these red dots:If I can achieve this, the labels will all fall back in line and be more visually appealing.To make thinks even more difficult, I should mention that our plots are not all rotated to the same angle, they can face any which way you can think of: Has anyone had any experience doing something li

i have a Problem with the Installing of FME Desktop i have this error " pascal.filippi is a invalid short name files"

I have an odd request. My user has a data set of 758 records. They want to sample 450 of these randomly.I've completed this using a sampler with a random sampling. However, the client wants to add further columns of data to the existing random sample.If I rerun this workspace.I'll generate a new random set of data than before. How do I add a random number to a row, but keep this created number so that when I run the workspace again I get the same sample as before? Thank you!N