Transformers

If I had the following string how would I remove a repeated word in this case the word Pensions. So I want to remove the first word that has Pensions but keep the second one.2006SourcesOfPersonalIncomeTotalResponses06OtherSuperOrAnnuitiesOtherThanNZSuperVeteransOrWarPensionsCURP15YrsAndOver2006SourcesOfPersonalIncomeTotalResponses06OtherSuperPensionsOrAnnuitiesOtherThanNZSuperVeteransOrWarPensionsCURP15YrsAndOver

As per title, Sorter does not work properly in FME2018 when fed from a FeatureJoiner that supplies Features downstream in Bulk Mode. It's similar to the bug that @takashi found when FeatureJoiner supplies Features to AttributeManager.Attached workspace to show how Sorter does not work when fed directly from FeatureJoiner, but does work if put in an AttributeKeeper to split the features out of Bulk Mode into "Normal" Mode.Workaround is to add a Transformer like AttributeKeeper (and sure there are other Transformers that may do it too).Question is, has this been resolved in latest FME or is this still an issue?

I am trying to get all of the Characters in a string that occur before the following " /" (thats a space followed by a /). Here is the catch there could be spaces and / before the occurance of the " /" and I want to keep those in the found string.I was trying to use the stringSearch and do this in one step (I was able to do this in 2 steps by first stringReplace the " /" with a character I knew would not appear and then doing a stringsearch but this should be doable in one step with the correct regEx expression)Here are examples123ABD / 99 - "123ABD" would be found123/ABD / 99 - "123/ABD" would be found123% ABD/99 / 789 - "123% ABD/99" would be found123 / 456 / 789 - "123" would be foundhopefully this makes it clearThxin advance to you RegEx wizards out there...

How to trace network from source to destiation .if i know source and destination then how to check or trace element beetween them .

I have spent hours re-engineering my data but couldn’t find a best resolve to automate data to provide statistics. Thinking, I could have saved myself a lot of trouble with a simple transformer with set logic using FME.    I have a range of attributes containing values such as "Class1, Class1a, Class3, Class4a". values are picked up from a drop down list by the surveyors, that sits in an attributed separated by comma (,).   I need to count the number of items in each attribute, assuming that they were separated by commas. So, the transformer would need to return the value 4 for my example above and for various other attributes using the same logic. I need to use the logic "If the cell is blank, value= 0, if the cell is not blank, but does not contain a comma, value=1, otherwise, value= (number of commas +1) i.e. read the string, if there are two commas in the string, then there must be three value

Hi, I'm using the Strava HTTPCaller that is posted on https://hub.safe.com/publishers/gerhardatsafe/web-connections/strava, I'm able to extract the polyline, but when it gets inputted into geometry replacer, I always get the error INVALID_PARAMETER_GEOMETRY_SOURCE. I can take the same polyline and input into the google polyline decoder https://developers.google.com/maps/documentation/utilities/polylineutility with no issues. Any ideas? Below is the encoded polylineir}gGdp`fNWfAaAbDObAY`DUfASh@]n@y@vAeA~AET@JNTtAzAfBxBhBlCjAfB~@pA~HvIxFnFJNBPANGN}CtEkBtCUX}EzHuNtT{DnGa@|@[j@wTd]yIxNwD~FgA~Au@x@GT@NJZ^f@dGtGpRfTpIhJ~^`b@bBdBp@z@bJdKTZR^p@h@pArAz@fA~KfMdJjKvJ|KlDzD|KdMfEdF~PpRdAnAt@v@l@x@`AbA|AlBPVJ\\\\H^@^Ch@CRQn@Yn@]d@YLWFu@Hm@LmARg@

I am using FME Server to move very large files into an Azure data store. The mechanism of this works fine but I would like to delete the files from FME servers temporary file store after the files are used to avoid filling up the memory of the server.I know that the temporary uploaded files end up in the following location but not how to delete them:FME_SHAREDRESOURCE_SYSTEM/filesys/temp/upload/Project1/AzureUpload.fmw/Username/*filename* Thanks!

I want to create a reference table within the workspace so I don't have to import another data source. I feel like I am missing something easy. I want to create a simple table ofRoleRateAdministrator£20Operative£30Manager£40Director£50 I can then join my data to it to get the rates.I would usually write the table in excel then read it in a featuremerger to match the rates in.I feel there must be a way to do this in FME rather than have to read the external data source. It must be more efficient. Thanks 

I have an ArcGIS Online Feature Layer with Fire Hydrant points, these hydrants have a unique ID from our asset management system. I am creating new points while carrying out inspection, using a mobile device, it creates a point within a few meters of the original hydrant. I want FME to grab this new point, move it over the original point, and insert the unique ID into a column of the new point. Is this simple to do? I have done some googling but nothing has jumped out at me. Thanks!

Hi, does anyone have any suggestions how to do this?I have a set of lines with measures and need to create points at each 1/10 measure value. A line with a measure range of 1 - 2.5 would result in points at measures 1.0,1.1,1.2,1.2....2.3,2.4,2.5The distance between the measure interval is NOT consistent, so length cannot be used.The functionality would be like the Chopper by measure interval.I'm using FME 2019.1. Thanks in advance!Kathy

Hello  I can't find a simple solution for the scenario below: if you look on the diagramm, I want to put my uuid value with fk_type=1 in the fk_parent_uuid field when fk_type=2 but I make a big package of spaghetti instead Would you have a brilliant idea ? thanks

Hello everyone,I'm new here, and hope I can use the friends' knowledge here.I'm trying to translate a CAD file to GDB. I have a template GDB file, and I want all the values from the CAD file to be passed by subtype and domains.I tried to move as I learned, and got stuck in some problems ...At the end of the process he writes to me: Translation was SUCCESSFUL.But the result is far from what I am looking for.There are 126329 warnings, and as a result the GDB is completely empty, not to mention that nothing entered the domain or the subtype. The transition, and its understanding, are really important to me for continuing to work, and I would be really happy if anyone could help.This is the beginning of the warnings:Then almost the warnings look like the bottom lines (104....) 

Hi Folks,I have a table CSV with these values :I would like with SchemaMapper, to transform Old componants (named src_cmp) and old attributes (named src_attr_1) and their old values (named scr_value) to New componants (named dest_cmp) and newattributes (named dest_attr_1) and their new values (named dest_value)I have used differents ways of parameters inside SchemaMapper, but didn't succeed.May anoone tell me if it's possible ?regards

Hi all,I wounder if anyone has a typical use case of the custom CoordinateSystemConvergenceCalculator ?https://hub.safe.com/publishers/safe-lab/transformers/coordinatesystemconvergencecalculator Basically my goal is to see if this transformer could handle the issue in Sketchup with the green axis versus the TrueNorth axis when geo-locating a model as discussed in this forum:https://forums.sketchup.com/t/solar-north-geolocation/18473/11  Thanks!

Hello,I have an export from callcenter software and I want to transform it like this.Original data is on the left and I want to become what's on the right. What I tried:Read the source Excel with columns A, B and C as attributes.Then with a TestFilter I created "Name", "Extension" and "Contents" port but I'm not able to join them.Any push in the right direction please? :-) Thanks and stay safe!-Jonathan

Hello everyone,  The Case: I have a 2TB Raster images source folder connected to a mosaic data set in fileGDB, I need to create/Publish workflow to clip a certain extent based on shapefile clipper to be uploaded by users on the server.  FYI: that the raster images/ mosaic dataset on a server and the FME is on another server.  The Situation:  Currently, I created the workflow below: It works fine from the desktop application a bit slow though.   When publishing I get the below:  How to make FME server connect to the file gdb with the raster mosaic dataset without uploading any files to the server?   

I have a problem using the appearance setter to apply JPEG textures to surfaces and outputting to FBX file (for input to Unity) using the attached workspace. The files appear to write out ok and I can see the textures applied in the Inspectors. But when I read the new FBX files there are no textures and I get this warning in the log. Any idea how to fix this?  "FBX_2: A texture used by mesh in node '' references a UV set named 'default', which doesn't exist"   

The starting point for my question is a table containing information about fruits and vegetables:IDNameTypeColorKcal1AppleFruitGreen522BananaFruitYellow893CarrotVegetableOrange414KaleVegetableGreen395ZucchiniVegetableGreen17 I would like to use FME to list all distinct values per column, including a count per distinct value, such as:ColumnNameVarietyNameCountNameApple1NameBanana1NameCarrot1NameKale1NameZucchini1TypeFruit2TypeVegetable3ColorGreen3ColorYellow1ColorOrange1Kcal521Kcal891Kcal411Kcal391Kcal171 I was considering to use an AttributeExploder to list all columns in separate rows, followed by a StatisticsCalculator to determine the count per variety. However, that seems to consume a lot of time for larger datasets (containing over 1.000.000 records).Does anyone have suggestions how to accomplish the above result in a better fashion?

During transformation, I don't want to change the position of attributes of blocks from Autocad.

I have multiple workspaces that are run in succession to process a job task. I need to collate some of the parameters that the user inputs into one file - csv or text doc, for QA and checking purposes. Is there a way to achieve this?

Again I hope the title is self explanatory, but below is a sum up;Say you start of by creating some attributes with an attributecreator;Then, when you connect an AttributeManager, it looks something like this;If you now want to create or include some extra attributes from another AttributeManager, you can 'paste them in'.First you select the row from another AttributeManager which you want to copy the row (right click on the row, and choose 'Copy Row' (or use either the Ctrl+C shortcut or the dedicated copy button));However, the problem then arrives when you paste this row into the original attribute ma

I am looking to filter out specific types of addresses from a full dataset of addresses. These addresses include points that can represent the main address (ADDRESS_BASE) (ex: 123 main street), or addresses that include a suite addresses (LVAPT_ADDRESS) (ex: #3, 123 main street). Scenario 1: If the main address and the suite address are all stacked at the same XY, then I want to select the main address (this isn't hard)Scenario 2: If there are groups of suite addresses with the same main address on a building but with each slightly different XYs then:Option A: if the group with the same main address is all on one building then select the main addressOption B: if the group with the same main address is on more than one building then keep all addresses. My brain is getting tired of running through different ways to make these different kinds of selections/filters. I have tried the Matcher because it includes a MATCH_ID

Hi, I have a landscape colored after value, and when I press inspector before features are written I can see them in perfect colors as they should, but when I open the written dwg in AutoCAD or Bentley Viewer everything is just red, and I dont know why. Pictures: The lines in wireframe view and conceptual view etc is just the same color in Autocad even when the look fine when inspected jsut before written, I tried using Regions instead but doesnt work. 

Hello, i want to use as input for the pointcloudcombiner certain files, which i have written in different attributes (neigbor_[0-7] of one feature (eg 2671_1262). These are the neighbouring tiles of lidar data. So far I have not found a way how I can pass the attributes (complete file path + filename) or a list as input to the PCCombiner. Is there an elegant way for this in FME?

HelloAfter an "attributeKeeper" transformer I try to obtain a selection with distinct value for each row like a "select distinct" sql command. But I fail to find a good solution. (I didn't find the DuplicateRemove transformer)Do you know to do it ?Thanks